from backend.app.app.db.session_public import session_pub
import backend.app.app.models.db_owi_public_models as md_pub

# 获取开发单元年度油井措施经济评价结果表信息
def get_evaluate_result():
    try:
        evaluate_result_inf = session_pub.query(md_pub.TbYearDvpunitOilprodcost.DvpUnit_Name,  # 开发单元
                                                md_pub.TbYearDvpunitOilprodcost.Year,
                                                md_pub.TbYearDvpunitOilprodcost.Oil_OprCost,
                                                md_pub
     # 备注
                                                ).all()
        # welloprcost(md_pub.TbYearDvpunitOilstimulateEvaluateResult.Stim_IncreOil_Critical_Average,
        #             md_pub.TbYearDvpunitOilstimulateEvaluateResult.Oil_OprCost)
        # print(evaluate_result_inf)
        return evaluate_result_inf
    except:
        print('查找信息失败')
        session_pub.rollback()
        return False